Custom Sql Statement To Query From Multiple Tables
I'm a newbie and totally new to bartender and SQL.
I wanted to print shelf lables and my SQL database has Barcode1,Barcode2,Barcode3... Barcode6. Similarly ,Description 1 to 6 and Price 1 to 6.
I wanted barcode to be queried. So when a barcode is scanned, it has to be looked in to the barcode 1 to 6 tables, and fetch the description and price accordingly and print it.
Need your help to achieve this.
-
Have you added all the different labels to the label and setup the joins between to say what fields in each of the table is the same balue as the other table (eg> Barcode in table1 = Barcode in table2 and then the same to add the price table but not necessarily the same item such as Product Code in the 1st or 2nd table is the same as Item Code in the third table)?
Once you have completed that you then need to setup your actual query or filter, dependent on which version of BarTender you are using parameter.
In most instance you may not need to use a Custom SQL statement and can just use the inbuilt tool
(I think this should have been in a the BarTender.....Database forum rather than this one for System Database, and not sure if it can be moved there, but never mind anyway)
0
Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.
Kommentare
1 Kommentar