SELECT * FROM
( SELECT 'one' AS TableName, 'display' AS FieldName, display_name AS Search FROM One AS O1
UNION
SELECT 'one', 'name', name FROM One AS O2
UNION
SELECT 'two', 'display', display_name FROM Two AS T1
UNION
SELECT 'two', 'name', name FROM Two AS T2
UNION
SELECT 'three', 'display', display_name FROM Three AS T3
UNION
SELECT 'three', 'name', name FROM Three AS T4) AS TableSearch
WHERE Search = 'Word'SELECT name, sn, invn, type_eq, location, note1
FROM equipment
LEFT JOIN moving_eq2 ON moving_eq2.id_eq = equipment.id_eq
WHERE moving_eq2.id_eq IS NULL
SELECT 'ученик', ID FROM Ученики
UNION
SELECT 'учитель', ID FROM Учителя
UNION
…Персона ( Код, Тип, Имя … ), тогда ЧитательскийБилет ( Код, КодПерсоны, Номер … ).
DECLARE @ID_TeamMembers INT
-- для Bids.[Имя члена команды1]
SELECT @ID_TeamMembers = ID FROM TeamMembers WHERE …
IF @ID_TeamMembers IS NULL
INSERT INTO TeamMembers …
ELSE
UPDATE TeamMembers SET … WHERE ( ID = @ID_TeamMembers )
-- Повторить для Bids.[Имя члена команды2] и так далееupdate TeamMembers set name = нет значения. Для каждого поля нужно писать отдельный подзапрос.DECLARE @ID_TeamMembers INT
SELECT @ID_TeamMembers = ID FROM TeamMembers WHERE …
IF @ID_TeamMembers IS NULL
INSERT INTO TeamMembers …
SET @ID_TeamMembers = IDENT_CURRENT( 'TeamMembers' ) -- чтобы не был NULL, может нужно будет
ELSE
UPDATE TeamMembers SET … WHERE ( ID = @ID_TeamMembers )SELECT Income.id, max_date, MAX(value)
FROM Income
INNER JOIN (SELECT id, max(date) as max_date FROM Income GROUP BY id) IM
ON Income.id = IM.id AND Income.date = max_date
GROUP BY Income.id, max_dateпредпоследний документ по дате создания … order by запрещеноЭто максимальная дата меньше максимальной:
SELECT [Name], MAX(StartDate)
FROM [Period]
WHERE (StartDate < (SELECT MAX(StartDate) FROM [Period] AS MaxDate
WHERE (MaxDate.[Name] = [Period].[Name])))
GROUP BY [Name]
SELECT customer.name, COUNT(`order`.id)
FROM customer
INNER JOIN `order` ON customer.id = `order`.customer_id
GROUP BY customer.name