it is possible to search a field in a middle of another field of
another table?
I try something like:
SELECT * FROM TABLE1, TABLE2 WHERE TABLE1.FIELD1 LIKE

i've apparently hit a brick wall in my understanding of table
relationships.  Say I have the following:
widgets:
id     widget

My company is about to grow substantially and so will our database.
Currently, we obtain vessel data from our clients i.e. speed, lat/long
track, boundaries entered, etc..  Typically, one vessel will generate
approx. 90000 lines of data (each row of data has about 10 fields) per

Hello :-)
Introduction:
Delphi Multiuser application
Database: Firebird

I'm not sure if this topic goes here but, I'm looking for a c++ library
that can read a file and use that file as a database.  For instance,
the excel libraries for microsoft that can read and write to excel
files.  

I'm puzzling to get some values from the following tables, 'historie'
and 'zonegroepcomb_historie' .The two tables contains modified data from
e.g. update, insert and deleted data from a table named 'zonegoepcomb'.
I would like to extract the related 'allowed_zone_id' from

It was always mentioned that it might take longer to optimize
a complex query than actually run the query itself. For complex
query optimization, the optimizer needs tens of megabytes to
store all the intermediate optimization results (partial plans, etc)

Hi, all!
Here's my situation.I have about 10 tables, which contain order
numbers. Those numbers are not unique inside tables.
My task is to populate and maintain separate table ,let's call it

I want to do a SELECT COUNT(*) for some SELECT-Statements created
in other parts of an application and I don't know exactly what
that elsewhere created SELECT looks like.
So i thouht something like 'SELECT COUNT(*) FROM ( ... )' might

What tasks should a database administrator do to maintain a database well?

Has a new version of MySQL been developed that does a better job
of linking non-MS C programs? I recall that I stopped using the
product because it could only link with Microsoft modules, while
I needed to link with GNU C-compiled objects. Has that changed?

I am new to MySQL and am trying to develop a windows application with
C/C++ to access MySQL database to execute some queries using ODBC. I
have installed MySQL ODBC driver.
(1) Does anyone know where are the destination of MySQL ODBC driver

Excuse me. This probably is off-topic
I am finding a newsgroup about postgresql, but I can't find it.
Can anyone help me?

Some customer experienced scalabillity problems with their setup. They
were using MySQL and were using multiple MySQL servers, each with their
own CPU + disk which replicate to each other.
I was wondering: wouldn't it be better to have multple MySQL deamons

I'm looking for program - something like old dos FoxPro 2.* or dBase
I have two tables in two dbf files.
I wont to connect to them and make some sql.
Of course I know that there is M$ ForPro;)  But I'm looking something