sql server ce query question


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: sql server ce query question

  1. #1
    Join Date
    Mar 2008
    Posts
    164

    sql server ce query question

    hi,
    i have two tables
    products that have the name and code and stock_products that have the
    current stock

    and i want in a single query see the especific value of the table stock_products
    for example

    from table one: code of product and from table two the stock of the
    product

    in secund table i have many records that belong for the same product
    but i want only the last record

    now the great question
    how can i do that?
    thanks a lot for your help

    i using sql server ce

  2. #2
    Join Date
    Apr 2007
    Location
    Sterling Heights, Michigan
    Posts
    8,666
    How are the two linked?

    From your description, I see no common fields which would indicate how a record in one table is directly related to a record in the other table.
    I don't answer coding questions via PM or Email. Please post a thread in the appropriate forum section.
    Please use [Code]your code goes in here[/Code] tags when posting code.
    Before posting your question, did you look here?
    Got a question on Linux? Visit our Linux sister site.
    Modifications Required For VB6 Apps To Work On Vista

  3. #3
    Join Date
    Mar 2008
    Posts
    164
    hi,
    the colums of the stock_products are:

    stock
    codartigo
    date

    and the colums of the products are:

    id
    codartigo
    date

    the colums in common if: codartigo
    thanks a lot for your help

Similar Threads

  1. Return Query Estimate for SQL Server 2000
    By Daniel Reber in forum VB Classic
    Replies: 0
    Last Post: 09-16-2002, 02:50 PM
  2. Connect SQL Server Box to Oracle Box
    By Mark in forum Database
    Replies: 5
    Last Post: 07-15-2002, 10:24 AM
  3. Access to SQL server
    By Nate in forum Database
    Replies: 29
    Last Post: 05-09-2001, 10:04 AM
  4. Replies: 2
    Last Post: 10-14-2000, 02:09 AM
  5. SQL server administrative knowledge
    By Becky in forum Database
    Replies: 1
    Last Post: 07-11-2000, 03:27 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center