How to configure Rational Record List to execute this query:
SELECT * FROM Stock,Item,Warehouse WHERE Stock.itemID=Item.ID AND Stock.warehouseID=Warehouse.ID
So,i need to join table Stock with tables Item and Warehouse. Please help, i keep getting UNION ALL between these two relationships,which is not what i want.
SELECT * FROM Stock,Item,Warehouse WHERE Stock.itemID=Item.ID AND Stock.warehouseID=Warehouse.ID
So,i need to join table Stock with tables Item and Warehouse. Please help, i keep getting UNION ALL between these two relationships,which is not what i want.