Horje
sql join on a subquery Code Example
sql join on a subquery 
SELECT * 
FROM
( SELECT ... FROM ... ) q1

INNER JOIN

( SELECT ... FROM ... ) q2

ON q1.colname = q2.colname
Source: stackoverflow.com
sql join on a subquery 

	(select coalesce((select name from object_value where object_id = addtl_type.id 
    and object_type_id = @object_type_des_UDF
    and language_id = @language_id),addtl_type.name) from addtl_type
    where id = (select n_value from pr_addtl_data where pr_id = PR.ID and 
    data_field_id = (select id from data_fields where name = 'Category'))) as 'Category',



Sql

Related
add new column in sql with foreign key Code Example add new column in sql with foreign key Code Example
how to between in sql Code Example how to between in sql Code Example
how to force truncate a table in mysql Code Example how to force truncate a table in mysql Code Example
See Foreign Key Code Example See Foreign Key Code Example
add column in sql Code Example add column in sql Code Example

Type:
 Code Example
Category:
 Coding
Sub Category:
 Code Example
Uploaded by:
 Admin
Views:
 6



 

Horje