Select * from Table1 a left join Table2 b on (a.id = b.id) where a.id <> '1'

select a.id, a.colname, b.colname from Table1 a join Table2 a on (a.id=b.id) where a.id = '1' order by a.id asc

he gives a shared code :)

and don't forget to stop a server for a while when you want to backup data cause it will give you an error.

yeah, i do this way if i want to backup my database. i think this is a simple way.:)

maybe sqlserver 2005 more better to use.

your code just less single quote sign.
select TBIn.NoTbin,TBIn.IdBrg, Barang.NameBrg,TBIn.SupCode,Supplier.SupName from TBIn,Barang,Supplier
where TBIn.SupCode=Supplier.SupCode and...

absolutely RamyMahrous.

yeah, you're welcome and thx to nav33n to nice recovery. :)
don't forget to mark this solved.
All for the best.

ah, i'm sorry for this failure. thx for the recovery.:)

SELECT * FROM Customers where EmailAddress like '%" @ "%'"