Here is my table/field layout:
There is a one-to-many relationship from CATS table to ADS table on CAT_ID.
What does my SQL query statement need to look like if I want to show all the records where AD_APPROVED is equal to 1.
I want to be able to use all the field names later in the script, so the select statement should capture those.
Thanks in advance.