Match Syntax - General SQL Database Question & Answer - LearnSqlServer.com's SQL Server Forums

Member of the LearnItFirst.com Video Training Network	\| LearnSqlServer.com \| SQL SSIS Training \| SQL Programming Tutorials \|

Welcome Guest

Search | New Posts | Members | Log In | Register

LearnSqlServer.com's SQL Server Forums » SQL Server Database Administration » General SQL Database Question & Answer » Match Syntax

Match Syntax

Options

Previous Topic · Next Topic

marygrl2327

Posted: Tuesday, August 26, 2008 10:09:54 AM

Rank: Newbie

Joined: 6/13/2008
Posts: 7
Points: 21
Location: TX

I have the SQL for Dummies book and it gives a little section on using Match in a query if you have data that you want to match in a table, but it didn't go too much into depth on how you write the syntax. The example the book uses is a customer returning a toy airplane that she bought on a specific date. The book states you can verify the information by using Match with a code similar to the one below.

Code:

...Where(:vcustid, 'F-117A','2003-05-18')
MATCH
(SELECT CustomerID, ProductID, SaleDate
FROM SALES)

My understanding is that you have to know the data that you're looking for, except in the code example above it doesn't give the customer's id. I'm just a little bit confused on how the syntax works.

What's with today, today?

Scott Whigham

Posted: Tuesday, August 26, 2008 8:55:38 PM

Rank: Super Mod

Joined: 3/20/2006
Posts: 345
Points: 748
Location: Dallas, TX

I'm sorry - I don't think SQL 200x supports this type of query. I could be wrong though but I've never seen one.

Users browsing this topic

Guest

Forum Jump

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.