Re: SELECT statement with sub-queries

On 2017-05-28 11:23:47 Adrian Klaver hacked into the keyboard:
> On 05/28/2017 10:53 AM, Michelle Konzack wrote:
> >>
> >>SELECT * FROM products WHERE category IN
> >> (SELECT categories.cat FROM categories WHERE
> >> categories.serial = products.category);

> Because you are comparing categories.cat

ehm no

I want to replace in the output the numerical ID from "products.category"
with the value of "categories.cat", where the "products.category" match
the "categories.serial"

> which is a varchar to
> products.category which is an integer. The above is crying out for
> FOREIGN KEYS. For the time being I going to assume products.category
> is a faux FK to categories.serial so;
>
> SELECT * FROM products WHERE products.category = categories.serial;

This is not working

--
Michelle Konzack Miila ITSystems @ TDnet
GNU/Linux Developer 00372-54541400