2 tables one query.

[running frag]

now i have this :

1 table agt :
agtID
crpID
staID
slrsysID

2 table crp :
staID
crpID
slrsysID
constID
regID


and such query - >
"SELECT agt.*, crp.* FROM agt, crp WHERE agt.crpID = '123456' && agt.crpID = crp.crpID"

and got result where column crpID dublicates (i have crpID and crpID_1). how can i join them in one column?

PS: MySQL 5.0.24a (win32), Apache 2.0.59 (win32-x86-no_ssl), browse by "My Manager Pro 3.4.0.4".



Edited 1 time(s). Last edit at 12/24/2008 02:46AM by running frag.