SQL Select语句复杂[关闭]

Question

I have two tables. One table has ID, Text. The other has ID, Username.

When someone logs into the page, they have a username id, so username has a value.

I want to select ID and TEXT from table 1, where ID matches ID in table two and the value of Username for that ID grabbed is same as the person logged in.

Answer 1

Replace t1 and t2 with your appropriate table names. I'm not sure what language you're using for the code, but replace with the value of the user that is logged in.

SELECT t1.ID, t1.TEXT
FROM t1
LEFT JOIN t2 on t2.ID = t1.ID
WHERE t2.username = '<some username>'

After your comments, here's the new query:

$Query = "SELECT LandingPage_Notification.ID, LandingPage_Notification.Title, LandingPage_Notification.HTML,LandingPage_Notification.DateExpiry FROM LandingPage_Notification LEFT JOIN Track_Notification on Track_Notification.ID = LandingPage_Notification.ID WHERE Track_Notification.Track_UserID= '$userName'";