Table Join to Flag Interest

[Lost User]

I want to join these 2 tables Products_Table & Interest_Table. When somebody is logged in they get a flag next to the product that they said they where interested in. I request the cookie to get the pwl variable in the Interest_Table. I’m looking for the sql statement that works in access.. Products_Table Prod_ID Prod_Name 1 Dog 2 Cat 3 Horse 4 Truck 5 Car Interest_Table ID Pwl Flag 1 Bob Flagged 1 Tom Flagged 4 Bob Flagged 5 Tom Flagged When Tom is logged in he will get this list. 1 Dog Flagged 2 Cat 3 Horse 4 Truck 5 Car Flagged When Bob is logged in he will get this list. 1 Dog Flagged 2 Cat 3 Horse 4 Truck Flagged 5 Car When nobody is logged in they get this list. 1 Dog 2 Cat 3 Horse 4 Truck 5 Car

[Mycroft Holmes]

Why do you insist that the database does something that the UI has the information for! The database does not know what should be flagged, you get it from a cookie. So when you have the datatable back from the database you can then add the column and populate the flagged records.

Never underestimate the power of human stupidity RAH