Re: Item Tracking via Multiple Tables

[Christopher Esbrandt]

I suppose that's along the lines of what I'm looking for.

Here's another way to break down the problem. Basically, I need 2 queries (to my understanding on what can be done in MySQL). The first would be along the lines of: SELECT * FROM connector WHERE uid = 4;

This identifies which of the `id`'s from 'fruit' (`tid` in connector) is present. In the second query, you pull the content of 'fruit' and add the column saying "Yes, the `tid` was found in the first query" or "No, the `tid` was not found in the first query".

Problem is, I can't figure out how-to make a CASE statement to generate that column that works.