dbf select distinct sql using VB

Posted on 2013-10-07
Medium Priority
Last Modified: 2013-10-16
can you help me how to join 2 tables and select distinct items the other database is dbf the other is an sql file thanks :)
Question by:kennethzxc
LVL 49

Accepted Solution

PortletPaul earned 1500 total points
ID: 39555305
Do you have any other details to share?
table names?
database names?
how the tables join?
what columns need to be distinct?

Do you have any queries working across these 2 data sources currently?

Right now I don't believe this question can be answered.

Author Comment

ID: 39558841
it's an attendance so the dbf is passing data to the vb and i query in the vb about the dbf and pass the value to sql server .
so i just want to pass the values that are inputed in the dbf where curddate or the date and time now - 20000 secs :D it's dynamic and its running on a service thanks :D
i'll post the query tom
it's like

VB.DBF query = Select empno,logtime where datetime = current date and time - 20000 secs ? i don't know how to query it :D

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

SingleRun is a tool that ensures that only one instance of an application is started, running it again brings the application to focus.
Ready to get certified? Check out some courses that help you prepare for third-party exams.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

600 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question