I have
TABLE1 with columns 1A 1B 1C(PK)
TABLE2 with columns 2A 2B 2C(PK)
TABLE3 with columns 3A 3B 3C(PK)
TABLE4 with columns 1C 2C 3C 4D
my sql =
select TABLE1.1A, TABLE1.1B, TABLE1.1C, TABLE2.2A, TABLE2.2B, TABLE2.2C, TABLE3.3A, TABLE3.3B, TABLE3.3C from TABLE1 TABLE1, TABLE2 TABLE2, TABLE3 TABLE3, TABLE4 TABLE4 where ( TABLE4.1C = TABLE1.1C AND TABLE4.2C = TABLE2.2C AND TABLE4.3C = TABLE3.3C AND TABLE4.4D = '
TEST')
but my query gives me duplicate rows, when i run
select * from TABLE4 where TABLE4.4D = 'TEST'
i get about 1500 rows but with actual query i get close 7000 queries, where these counts should be the same.
Any help is appreciated