Re: Item Tracking via Multiple Tables

[Christopher Esbrandt]

I did say it: I need to list the contents of one table and whether or not the entries are tied to the connector table.

If you're referring to the filter of the would-be query results, it's at the top of that: UID 4 has

So: SELECT a.id, a.name, %IF a.tid FOUND IN b.tid THEN 1 ELSE 0 ENDIF% FROM fruit a LEFT JOIN connector b ON a.id = b.tid WHERE b.uid = 4;

I'm aware that this isn't a "proper" query, just trying to explain it in English, since I failed to do so the first time.