ASP.NET SOLUTIONS with SOURCE CODE
Pages
Asp.Net
Ajax
JavaScript
JQuery
SQL
Linq
XML
MVC
WCF
Tutorial
Android
how to use subquery in sql
Syntax:
SELECT
[ColumnName]
FROM
[TableName]
WHERE
[ColumnName]
IN
(
SELECT
[ColumnName]
FROM
[TableName]
)
Example:
SELECT
ItemName
FROM
tblItem
WHERE
ItemName
IN
(
SELECT
ItemName
FROM
tblOrder
)
Newer Post
Older Post
Home
