هل يمكن لجملة SUBQUER ان تحتوي على JOIN ?

[el_saka]

هل يمكن لجملة SUBQUER ان تحتوي على JOIN

[هانى سند]

السلام عليكم
نعم يمكن لجملة SUBQUERY ان تحتوي علي JOIN
بالتوفيق

[hearthouse]

ما اهمية جميلة SUBQUER؟؟؟ اول مرة اسمه بها

[-=|mOOdY|=-]

A query is an operation that retrieves data from one or more tables or views. In this reference, a top-level SELECT statement is called a query, and a query nested within another SQL statement is called a subquery.

[ subquery_factoring_clause ]
SELECT
  [ hint ]
  [ { { DISTINCT | UNIQUE }
 | ALL
 }
  ]
  select_list
FROM table_reference
	[, table_reference ]...
  [ where_clause ]
  [ hierarchical_query_clause ]
  [ group_by_clause ]
  [ HAVING condition ]
  [ model_clause ]
  [ { UNION [ ALL ]
 | INTERSECT
 | MINUS
 }
 (subquery)
  ]
  [ order_by_clause ]

تم تعديل 14 يناير 2007 بواسطة moody_4u