
February 23rd, 2012, 05:25 AM
|
|
Contributing User
|
|
Join Date: Sep 2006
Location: Plovdiv. Bulgaria
Posts: 200
  
Time spent in forums: 2 Days 6 h 51 m 58 sec
Reputation Power: 11
|
|
|
You can't use nested selects that return more than one column and more than one result per row if they are in SELECT's "area".
In your case for every row from tbl2 you want to return all rows from tbl1. Try to join them with some condition or change the select. If you really want to get all rows from tbl1 for every record in tbl2:
select tbl2.Sid,tbl2.sname, tbl1.d_id, tbl1.d_address from tbl2,tbl1
|