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

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...

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

if i not wrong, it's the old name for what are now Xbase files.so basically anything that will open Xbase should open xdb.
It is also the extension given to Norton Anti Virus updates