Hi I have a table called "master" which look like this
id_master | month | day | infotype
<Serial> PK | <Varchar 3> | <Varchar 3> | <Varchar 5>
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
1 | May | 27 | 121
2 | May | 27 | 122
3 | May | 27 | 123
4 | May | 28 | 121
5 | May | 28 | 122
Which Primary Key (id_master) is the Foreign Key (id_master) of another table called "masterdetail" which look like this
id_masterdetail id_master argument color
<Serial> PK | <int4> | <Varchar 30> | <Varchar 10>
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
1 | 121 | house | blue
2 | 121 | house | blue
3 | 121 | building | white
4 | 122 | building | white
5 | 122 | house | yellow
I try tu run a query to ask for all the arguments, which color has the value "blue" and they had the date "May" "27"
I wrote something like this
select argument from masterdetail, master where color like 'blue'
and master.month like 'May'
and master.day like '27'
and master.id_master = masterdetail.id_master;
But I cant get the correct results!
How can I fix it?
---
Eduardo Vázquez Rodríguez <evazquez@insys-corp.com.mx>
Insys
Soluciones Integrales de Seguridad en TI
Tel (52 55) 5322 5218
Implantación
---