Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: RSmithwvsf
- Content: Threads
- Order by date
-
how to create a View
i need to create a view to comapare data from two different tables tbl1, will show r.id, fname,lname,admit,ftype tbl2 will show p.id,p.date now i need to see only recors where tbl1.admit=1 and tbl1.ftype = 'il'and where tbl2.date={?Date}and tbl2.id<>tbl1.id pluse the date feild is a numaric...- RSmithwvsf
- Thread
- Replies: 5
- Forum: Pervasive: Pervasive.SQL
-
Compairing dta in two tables
i use psql for my dbase i have created a view that gives reside id numbers fnames lnames admit and lvl of care i need to use crystal to get a list od numbers form the meal table for a singal date to be entered by the user and compare them to the list in the view and display the ones in the list...- RSmithwvsf
- Thread
- Replies: 9
- Forum: Business Objects: Crystal Reports 4 Other topics
-
Blocking all outgoing calls
i have an option 11c system. i need to setup a block for an ext so that only incomeing calls are allowed what options under class of service should i change?- RSmithwvsf
- Thread
- Replies: 14
- Forum: Nortel: CS1000 (Meridian) systems
