I want to get second(reference) table status using id in first query.
I am calling select * from table1;
this table1 contains one column called referenceid. This reference id details will be there in table2 (id,status,date....etc). At time the of calling select * from table1 I want to get reference id status instedof referenceid.
Please provide any query.
posted 4 years ago
Sounds like you want to join table1 with table2 to get a status from table2.
Query would be
t1.id = t2.id