I want making select from two tables without any common element
I'm trying this code, but I get incorrect syntax near ','.
select top 1 inventory.name, customer.name
where inventor.name='test' , customer where customer.name='test2'
It leads to cartesian product of two tables. (Cross Join). Try like this,
SELECT TOP 1 i.NAME ,c.NAME FROM inventory i cross join customer c WHERE i.NAME = 'test' AND c.NAME = 'test2'