Welcome Guest ( Login | Register )

Help Creating SQL view to join product name and version name

Posted By saturation Tue 15 Mar 2011

Topic View

Author	Message
saturation	Posted Tue 15 Mar 2011
Supreme Being Group: Forum Members Last Active: Fri 30 Nov 2012 Posts: 108, Visits: 1,185 64,860	I need to create a SQL view that shows the name of the product in one column, each of the version names for each product in the next, and then each of the attributes as columns after the version. I'm not sure how to join the product and version tables with the tblKartrisLanguageElements--it's a little confusing. Can anyone help? Tags SQL View
	REPLY QUOTE LIKE 350

Threaded View

Threaded View

Help Creating SQL view to join product name and version name By saturation ( Tue 15 Mar 2011 )

Thanks! That definitely helped me out. By saturation ( Sat 19 Mar 2011 )

Thanks, Mohammad. That helped. How do the product and version... By saturation ( Thu 17 Mar 2011 )

Hi. You can study the views that are prefixed by vKartrisType like:... By Mohammad ( Fri 18 Mar 2011 )

Try this one: [code] SELECT vKartrisProductsVersions.P_Name,... By Mohammad ( Wed 16 Mar 2011 )