I need to union Customer Details and Vendor Details at one table(by business account). How i can do this?
Solved
Union Customer Details and Vendor Details at one table
Best answer by Django
You can start with the BAccount table as it contains customers and vendors (and employees and companies). Then you can left join to the Customer and Vendor tables.
Edit: You might also look at a projection (very similar to using a database view) to pull all of this data together for easier reporting.
You can start with the BAccount table as it contains customers and vendors (and employees and companies). Then you can left join to the Customer and Vendor tables.
Edit: You might also look at a projection (very similar to using a database view) to pull all of this data together for easier reporting.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.