jeudi 18 août 2016

Select from two tables without CommonElement

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 from inventory where inventor.name='test' ,  customer where customer.name='test2'

Aucun commentaire:

Enregistrer un commentaire