Untotal records

Suncoast

New member
Local time
Today, 02:35
Joined
Oct 28, 2009
Messages
8
is it possible to have a query that makes several records from a single record?

Example:

[TableA]
ID:1 Quantity:3 Length:10

[QueryA]
ID:1 Length:10
ID:1 Length:10
ID:1 Length:10
 
If you make a table with numbers 1,2,3 in it yes...
Select id,length
from yourtable,newtable
where newtable.number <= Quantity
 

Users who are viewing this thread

Back
Top Bottom