asked
Need to Fetch the data which are not present based on one particular ID
There is one master table which contains all the details of the customer. A view is been created on this master table to fetch the data from all other child tables which are connected to master table using foreign key constraints. There is one seller table which has the information about seller who sold to which customer, I want to show data of the master table for the seller who has not sold to a customer so that he can be assigned to the new customer. Note: one customer can have multiple seller assigned to him
By "not sold to a customer", do you mean "not sold to any customer", or "not previously sold to *this* customer"?
Also, some more concrete examples would help us to get a clearer picture of what you're up to / what you require. See, for example,
https://spaghettidba.com/2015/04/24/how-to-post-a-t-sql-question-on-a-public-forum/
sold to some customers but need to fetch the customers data which he has not been sold
Without access to your schema, it's difficult to know, but something along these lines? Tables * Seller - SellerID (key), company name, address, etc * Customer - CustomerID (key), name, shipping address, etc * Transactions - TransactionID, SellerID, CustomerID, Date, etc... Query: SELECT * FROM Seller WHERE SellerID NOT IN ( SELECT SellerID FROM Transactions ) Something like that?
18 People are following this question.
