When joining these two tables I first want to see if there is a record in the detail table that will join via serviceused, numofcolors is between numofcolorsmin and max, customer and category - if there is I want to return just that record with all the time saving columns. Master Table: |serviceused|numofcolorsmin| numofcolorsmax| customer |category |timesave|timesave2| several fields with timesaving values.ĭetail table: |serviceused|numofcolors|customer|category| |-|-|-|-| |SBC_JobShare |3 |1000177 |Hair Care |SBC_JobShare |3 |1000563 |Pets |SBC_JobShare |4|1000597 |Health & Beauty The master table contains serviceused, numofcolors_min, numofcolors_max clientid, categoryid. I have a detail table that contains serviceused, num_of_colors, clientid, categoryid
Nzabloc Asks: Joining Detail to Master table in SQL - possibility of two joins
0 kommentar(er)
