SELECT with data in another table

[Niavlys]

Hi,
It seems simple but I can't figure out how to do this. I have 2 tables (Printers and Cartridges). Here is the basic structure:

Printers                   Cartridges

ID                         idCartridge
idBlack                    cartNumber
idCyan                     
idYellow
idMagenta

I want to select all printers from table Printers but instead of having the ids for the cartridges, I want to link the tables to have the cartNumber instead.
I hope someone understands my problem. It's hard to explain.

Thanks for your help.

 

[simian336]

does ID = idCartridge?

Simi

 

[Niavlys]

No, ID is the primary key for Printers table.

idBlack = idCartridge
idCyan = idCartridge
idYellow = idCartdridge
idMagenta = idCartdridge

 

[simian336]

Try...

select P.id, c.cartNumber
from Printers p
join Cartridges C
on p.idBlack = c.idCartridge

Simi

 

[SQLBill]

If that doesn't do it, provide us sample data and what results you want to see.

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875