3 Discussion / Question Topics

Remove Filter
Member Avatar for
Member Avatar for haranaboy

Hi, I'm wondering if anyone can help me develop the right sql query. I'm trying to select a "customerNumber" in table 1, but only if it doesn't exist in table2. I tried this [CODE]Select Table1.customerNumber From Table1, table2 Where table1.customerNumber NOT IN (select table2.customerNumber from table2) [/CODE] It isn't right …

Member Avatar for simplypixie
0
216
Member Avatar for mijorog

In my database I have a datediscontinued. When someone runs a a report they select a start date (FORM.StartDate) and an end date (FORM.EndDate). I need to find the records where date discontinued is between the start and end date. If the start date is NEQ to the end date …

Member Avatar for arrgh
0
143
Member Avatar for dashawk

guys, can anyone help me on this problem? i have two tables then what I want is that, when an identical item is found in table2, it will not be displayed. Example: [CODE] Table1 Table2 item1 other1 item2 other2 item3 item2 item4 item3 [/CODE] Condition: if we use this query: …

Member Avatar for Reverend Jim
0
250

The End.