I have a stored procedure that is failing. The current query behind it is:
SELECT DISTINCT
<many, many values>
FROM
table1
LEFT OUTER JOIN table2 ON
(table2.key =
(select max (table2.key) from table2
where table2.key = table1.key) or
... (0 Replies)
example sql:
select a.a1,b.b1,c.c1,d.d1,e.e1
from a
left outer join b on a.x=b.x
left outer join c on b.y=c.y
left outer join d on d.z=a.z
inner join a.t=e.t
I know how single outer or inner join works in sql.
But I don't really understand when there are multiple of them.
can... (0 Replies)
Hi all,
I am trying to merge three lines into one in my unix text file.
My text file sis omething like this.
xxxxxxxxx
yyyyyyyyyyy
zzz
aaaaaaaaa
bbbbbb
ccccc
Expected out put is
xxxxxxxxx yyyyyyyyyyy zzz
aaaaaaaaa bbbbbb ccccc
I tried with awk as shown below. (23 Replies)
Hi,
I have a code where it traverses through each record froma table and creates records in another table. I use FOREACH cursor to do this, i'm using another cursor inside the FOREACH to fetch the details of other table. Please suggest me which would be more efficient, as this will run against... (2 Replies)
Hi,
I am trying to join two simple files but unable to do so properly.
File R1 :
100
101
102
105
.
.
1000
10001
File R2
100|x1
102|x2
1000|a1
10001|a2
and when i do (4 Replies)
Hi,
I have a unix file which has many lines, i need to join all the lines to single line.
Eg: myfile.txt contains:
a
123
45fg
try
and i need the output as :
a 123 45fg try
Please help me on this.
Thanks! (2 Replies)
Hi I'm comparing same files names which are in different folders .
The first for loop for the files in DAY1 folder and
the second for loop for the files in DAY2 folder .
the first IF condition is for checking whether the file names are equal
the second If condtion is for checking the... (4 Replies)
Hello folks
I have 2 files which are like this:
file (a):
id phenotype
100 1.2
200 -0.5
300 3.1
file (b)
id genotype
100 0 1 2 ......
200 1 1 1......
300 2 0 0 .......
I should mention in file (a) I have 2... (3 Replies)
Hello All,
I'm working on a Shell script to join data from two files using Join command but not able to get the desired output as its throwing me an error:
I have sorted the two files on the Column 1 numerically which is used as Join clause
File 1:
1,ABC,GGG,20160401
2,XYZ,KKK,20160401... (2 Replies)
Discussion started by: venkat_reddy
2 Replies
LEARN ABOUT CENTOS
tk_getjoinstyle
Tk_GetJoinStyle(3) Tk Library Procedures Tk_GetJoinStyle(3)__________________________________________________________________________________________________________________________________________________NAME
Tk_GetJoinStyle, Tk_NameOfJoinStyle - translate between strings and join styles
SYNOPSIS
#include <tk.h>
int
Tk_GetJoinStyle(interp, string, joinPtr)
const char *
Tk_NameOfJoinStyle(join)
ARGUMENTS
Tcl_Interp *interp (in) Interpreter to use for error reporting.
const char *string (in) String containing name of join style: one of "bevel", "miter", or "round".
int *joinPtr (out) Pointer to location in which to store X join style corresponding to string.
int join (in) Join style: one of JoinBevel, JoinMiter, JoinRound.
_________________________________________________________________DESCRIPTION
Tk_GetJoinStyle places in *joinPtr the X join style corresponding to string, which will be one of JoinBevel, JoinMiter, or JoinRound. Join
styles are typically used in X graphics contexts to indicate how adjacent line segments should be joined together. See the X documentation
for information on what each style implies.
Under normal circumstances the return value is TCL_OK and interp is unused. If string does not contain a valid join style or an abbrevia-
tion of one of these names, then an error message is stored in interp->result, TCL_ERROR is returned, and *joinPtr is unmodified.
Tk_NameOfJoinStyle is the logical inverse of Tk_GetJoinStyle. Given a join style such as JoinBevel it returns a statically-allocated
string corresponding to join. If join is not a legal join style, then "unknown join style" is returned.
KEYWORDS
bevel, join style, miter, round
TkTk_GetJoinStyle(3)